Kolumna SICKLEAVEID tabeli SLR_SICKLEAVE

Definicja kolumny SICKLEAVEID tabeli SLR_SICKLEAVE

Name

SICKLEAVEID

Code

SICKLEAVEID

Data Type

NUMBER(19,0)

Mandatory

Yes

Comment

 


Kolumna ADDITIONALREASONCODE tabeli SLR_SICKLEAVE

Definicja kolumny ADDITIONALREASONCODE tabeli SLR_SICKLEAVE

Name

ADDITIONALREASONCODE

Code

ADDITIONALREASONCODE

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ADDITIONALREASONID tabeli SLR_SICKLEAVE

Definicja kolumny ADDITIONALREASONID tabeli SLR_SICKLEAVE

Name

ADDITIONALREASONID

Code

ADDITIONALREASONID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ADDITIONALREASONISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny ADDITIONALREASONISPRINTED tabeli SLR_SICKLEAVE

Name

ADDITIONALREASONISPRINTED

Code

ADDITIONALREASONISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna CLOSEDT tabeli SLR_SICKLEAVE

Definicja kolumny CLOSEDT tabeli SLR_SICKLEAVE

Name

CLOSEDT

Code

CLOSEDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CLOSEDTISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny CLOSEDTISPRINTED tabeli SLR_SICKLEAVE

Name

CLOSEDTISPRINTED

Code

CLOSEDTISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna CLOSEOTHEROPTIONCODE tabeli SLR_SICKLEAVE

Definicja kolumny CLOSEOTHEROPTIONCODE tabeli SLR_SICKLEAVE

Name

CLOSEOTHEROPTIONCODE

Code

CLOSEOTHEROPTIONCODE

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna CLOSEOTHEROPTIONDT tabeli SLR_SICKLEAVE

Definicja kolumny CLOSEOTHEROPTIONDT tabeli SLR_SICKLEAVE

Name

CLOSEOTHEROPTIONDT

Code

CLOSEOTHEROPTIONDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CLOSEOTHEROPTIONID tabeli SLR_SICKLEAVE

Definicja kolumny CLOSEOTHEROPTIONID tabeli SLR_SICKLEAVE

Name

CLOSEOTHEROPTIONID

Code

CLOSEOTHEROPTIONID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna CLOSEOTHEROPTIONISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny CLOSEOTHEROPTIONISPRINTED tabeli SLR_SICKLEAVE

Name

CLOSEOTHEROPTIONISPRINTED

Code

CLOSEOTHEROPTIONISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna CONTINUATIONCAUSECODE tabeli SLR_SICKLEAVE

Definicja kolumny CONTINUATIONCAUSECODE tabeli SLR_SICKLEAVE

Name

CONTINUATIONCAUSECODE

Code

CONTINUATIONCAUSECODE

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna CONTINUATIONCAUSEID tabeli SLR_SICKLEAVE

Definicja kolumny CONTINUATIONCAUSEID tabeli SLR_SICKLEAVE

Name

CONTINUATIONCAUSEID

Code

CONTINUATIONCAUSEID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna CONTINUATIONCAUSEISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny CONTINUATIONCAUSEISPRINTED tabeli SLR_SICKLEAVE

Name

CONTINUATIONCAUSEISPRINTED

Code

CONTINUATIONCAUSEISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna INSERTDATE tabeli SLR_SICKLEAVE

Definicja kolumny INSERTDATE tabeli SLR_SICKLEAVE

Name

INSERTDATE

Code

INSERTDATE

Data Type

TIMESTAMP

Mandatory

Yes

Comment

 


Kolumna CREATIONDTISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny CREATIONDTISPRINTED tabeli SLR_SICKLEAVE

Name

CREATIONDTISPRINTED

Code

CREATIONDTISPRINTED

Data Type

NUMBER(1,0)

Mandatory

Yes

Comment

 


Kolumna INSERTINGPERSON tabeli SLR_SICKLEAVE

Definicja kolumny INSERTINGPERSON tabeli SLR_SICKLEAVE

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Kolumna DATEONEDT tabeli SLR_SICKLEAVE

Definicja kolumny DATEONEDT tabeli SLR_SICKLEAVE

Name

DATEONEDT

Code

DATEONEDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DATETWODT tabeli SLR_SICKLEAVE

Definicja kolumny DATETWODT tabeli SLR_SICKLEAVE

Name

DATETWODT

Code

DATETWODT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DTANDREFNUMBERSSECISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny DTANDREFNUMBERSSECISPRINTED tabeli SLR_SICKLEAVE

Name

DTANDREFNUMBERSSECISPRINTED

Code

DTANDREFNUMBERSSECISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna EARLYPREGNANCY tabeli SLR_SICKLEAVE

Definicja kolumny EARLYPREGNANCY tabeli SLR_SICKLEAVE

Name

EARLYPREGNANCY

Code

EARLYPREGNANCY

Data Type

VARCHAR2(35)

Mandatory

No

Comment

 


Kolumna EARLYPREGNANCYISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny EARLYPREGNANCYISPRINTED tabeli SLR_SICKLEAVE

Name

EARLYPREGNANCYISPRINTED

Code

EARLYPREGNANCYISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna ENTRY1ISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1ISPRINTED tabeli SLR_SICKLEAVE

Name

ENTRY1ISPRINTED

Code

ENTRY1ISPRINTED

Data Type

NUMBER(1,0)

Mandatory

Yes

Comment

 


Kolumna ENTRY1CDOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1CDOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Name

ENTRY1CDOCTORFATHERHOOD

Code

ENTRY1CDOCTORFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna ENTRY1CDOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1CDOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Name

ENTRY1CDOCTORFIRSTNAME

Code

ENTRY1CDOCTORFIRSTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY1CDOCTORID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1CDOCTORID tabeli SLR_SICKLEAVE

Name

ENTRY1CDOCTORID

Code

ENTRY1CDOCTORID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY1CDOCTORLASTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1CDOCTORLASTNAME tabeli SLR_SICKLEAVE

Name

ENTRY1CDOCTORLASTNAME

Code

ENTRY1CDOCTORLASTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY1CDOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1CDOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Name

ENTRY1CDOCTORSPECFULLNAME

Code

ENTRY1CDOCTORSPECFULLNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ENTRY1CDOCTORSPECID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1CDOCTORSPECID tabeli SLR_SICKLEAVE

Name

ENTRY1CDOCTORSPECID

Code

ENTRY1CDOCTORSPECID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY1CDOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1CDOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Name

ENTRY1CDOCTORSPECSHORTNAME

Code

ENTRY1CDOCTORSPECSHORTNAME

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna ENTRY1DOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1DOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Name

ENTRY1DOCTORFATHERHOOD

Code

ENTRY1DOCTORFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna ENTRY1DOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1DOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Name

ENTRY1DOCTORFIRSTNAME

Code

ENTRY1DOCTORFIRSTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY1DOCTORID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1DOCTORID tabeli SLR_SICKLEAVE

Name

ENTRY1DOCTORID

Code

ENTRY1DOCTORID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY1DOCTORLASTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1DOCTORLASTNAME tabeli SLR_SICKLEAVE

Name

ENTRY1DOCTORLASTNAME

Code

ENTRY1DOCTORLASTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY1DOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1DOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Name

ENTRY1DOCTORSPECFULLNAME

Code

ENTRY1DOCTORSPECFULLNAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna ENTRY1DOCTORSPECID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1DOCTORSPECID tabeli SLR_SICKLEAVE

Name

ENTRY1DOCTORSPECID

Code

ENTRY1DOCTORSPECID

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Kolumna ENTRY1DOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1DOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Name

ENTRY1DOCTORSPECSHORTNAME

Code

ENTRY1DOCTORSPECSHORTNAME

Data Type

VARCHAR2(200)

Mandatory

Yes

Comment

 


Kolumna ENTRY1STARTDT tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1STARTDT tabeli SLR_SICKLEAVE

Name

ENTRY1STARTDT

Code

ENTRY1STARTDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna ENTRY1STOPDT tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY1STOPDT tabeli SLR_SICKLEAVE

Name

ENTRY1STOPDT

Code

ENTRY1STOPDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna ENTRY2ISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2ISPRINTED tabeli SLR_SICKLEAVE

Name

ENTRY2ISPRINTED

Code

ENTRY2ISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna ENTRY2CDOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2CDOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Name

ENTRY2CDOCTORFATHERHOOD

Code

ENTRY2CDOCTORFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna ENTRY2CDOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2CDOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Name

ENTRY2CDOCTORFIRSTNAME

Code

ENTRY2CDOCTORFIRSTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY2CDOCTORID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2CDOCTORID tabeli SLR_SICKLEAVE

Name

ENTRY2CDOCTORID

Code

ENTRY2CDOCTORID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY2CDOCTORLASTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2CDOCTORLASTNAME tabeli SLR_SICKLEAVE

Name

ENTRY2CDOCTORLASTNAME

Code

ENTRY2CDOCTORLASTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY2CDOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2CDOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Name

ENTRY2CDOCTORSPECFULLNAME

Code

ENTRY2CDOCTORSPECFULLNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ENTRY2CDOCTORSPECID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2CDOCTORSPECID tabeli SLR_SICKLEAVE

Name

ENTRY2CDOCTORSPECID

Code

ENTRY2CDOCTORSPECID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY2CDOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2CDOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Name

ENTRY2CDOCTORSPECSHORTNAME

Code

ENTRY2CDOCTORSPECSHORTNAME

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna ENTRY2DOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2DOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Name

ENTRY2DOCTORFATHERHOOD

Code

ENTRY2DOCTORFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna ENTRY2DOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2DOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Name

ENTRY2DOCTORFIRSTNAME

Code

ENTRY2DOCTORFIRSTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY2DOCTORID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2DOCTORID tabeli SLR_SICKLEAVE

Name

ENTRY2DOCTORID

Code

ENTRY2DOCTORID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY2DOCTORLASTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2DOCTORLASTNAME tabeli SLR_SICKLEAVE

Name

ENTRY2DOCTORLASTNAME

Code

ENTRY2DOCTORLASTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY2DOCTORSPECIFULLNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2DOCTORSPECIFULLNAME tabeli SLR_SICKLEAVE

Name

ENTRY2DOCTORSPECIFULLNAME

Code

ENTRY2DOCTORSPECIFULLNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ENTRY2DOCTORSPECID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2DOCTORSPECID tabeli SLR_SICKLEAVE

Name

ENTRY2DOCTORSPECID

Code

ENTRY2DOCTORSPECID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY2DOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2DOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Name

ENTRY2DOCTORSPECSHORTNAME

Code

ENTRY2DOCTORSPECSHORTNAME

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna ENTRY2STARTDT tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2STARTDT tabeli SLR_SICKLEAVE

Name

ENTRY2STARTDT

Code

ENTRY2STARTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ENTRY2STOPDT tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY2STOPDT tabeli SLR_SICKLEAVE

Name

ENTRY2STOPDT

Code

ENTRY2STOPDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ENTRY3ISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3ISPRINTED tabeli SLR_SICKLEAVE

Name

ENTRY3ISPRINTED

Code

ENTRY3ISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna ENTRY3CDOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3CDOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Name

ENTRY3CDOCTORFATHERHOOD

Code

ENTRY3CDOCTORFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna ENTRY3CDOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3CDOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Name

ENTRY3CDOCTORFIRSTNAME

Code

ENTRY3CDOCTORFIRSTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY3CDOCTORID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3CDOCTORID tabeli SLR_SICKLEAVE

Name

ENTRY3CDOCTORID

Code

ENTRY3CDOCTORID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY3CDOCTORLASTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3CDOCTORLASTNAME tabeli SLR_SICKLEAVE

Name

ENTRY3CDOCTORLASTNAME

Code

ENTRY3CDOCTORLASTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY3CDOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3CDOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Name

ENTRY3CDOCTORSPECFULLNAME

Code

ENTRY3CDOCTORSPECFULLNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ENTRY3CDOCTORSPECID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3CDOCTORSPECID tabeli SLR_SICKLEAVE

Name

ENTRY3CDOCTORSPECID

Code

ENTRY3CDOCTORSPECID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY3CDOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3CDOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Name

ENTRY3CDOCTORSPECSHORTNAME

Code

ENTRY3CDOCTORSPECSHORTNAME

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna ENTRY3DOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3DOCTORFATHERHOOD tabeli SLR_SICKLEAVE

Name

ENTRY3DOCTORFATHERHOOD

Code

ENTRY3DOCTORFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna ENTRY3DOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3DOCTORFIRSTNAME tabeli SLR_SICKLEAVE

Name

ENTRY3DOCTORFIRSTNAME

Code

ENTRY3DOCTORFIRSTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY3DOCTORID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3DOCTORID tabeli SLR_SICKLEAVE

Name

ENTRY3DOCTORID

Code

ENTRY3DOCTORID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY3DOCTORLASTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3DOCTORLASTNAME tabeli SLR_SICKLEAVE

Name

ENTRY3DOCTORLASTNAME

Code

ENTRY3DOCTORLASTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna ENTRY3DOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3DOCTORSPECFULLNAME tabeli SLR_SICKLEAVE

Name

ENTRY3DOCTORSPECFULLNAME

Code

ENTRY3DOCTORSPECFULLNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ENTRY3DOCTORSPECID tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3DOCTORSPECID tabeli SLR_SICKLEAVE

Name

ENTRY3DOCTORSPECID

Code

ENTRY3DOCTORSPECID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ENTRY3DOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3DOCTORSPECSHORTNAME tabeli SLR_SICKLEAVE

Name

ENTRY3DOCTORSPECSHORTNAME

Code

ENTRY3DOCTORSPECSHORTNAME

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna ENTRY3STARTDT tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3STARTDT tabeli SLR_SICKLEAVE

Name

ENTRY3STARTDT

Code

ENTRY3STARTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ENTRY3STOPDT tabeli SLR_SICKLEAVE

Definicja kolumny ENTRY3STOPDT tabeli SLR_SICKLEAVE

Name

ENTRY3STOPDT

Code

ENTRY3STOPDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ENTRYENDDT tabeli SLR_SICKLEAVE

Definicja kolumny ENTRYENDDT tabeli SLR_SICKLEAVE

Name

ENTRYENDDT

Code

ENTRYENDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ENTRYQUANTITY tabeli SLR_SICKLEAVE

Definicja kolumny ENTRYQUANTITY tabeli SLR_SICKLEAVE

Name

ENTRYQUANTITY

Code

ENTRYQUANTITY

Data Type

NUMBER(10,0)

Mandatory

Yes

Comment

 


Kolumna EVENTID tabeli SLR_SICKLEAVE

Definicja kolumny EVENTID tabeli SLR_SICKLEAVE

Name

EVENTID

Code

EVENTID

Data Type

NUMBER(19,0)

Mandatory

No

Comment

 


Kolumna GUARDIANBIRTHDT tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANBIRTHDT tabeli SLR_SICKLEAVE

Name

GUARDIANBIRTHDT

Code

GUARDIANBIRTHDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna GUARDIANFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANFATHERHOOD tabeli SLR_SICKLEAVE

Name

GUARDIANFATHERHOOD

Code

GUARDIANFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna GUARDIANGENDER tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANGENDER tabeli SLR_SICKLEAVE

Name

GUARDIANGENDER

Code

GUARDIANGENDER

Data Type

NUMBER(10,0)

Mandatory

No

Comment

 


Kolumna GUARDIANID tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANID tabeli SLR_SICKLEAVE

Name

GUARDIANID

Code

GUARDIANID

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna GUARDIANNAME tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANNAME tabeli SLR_SICKLEAVE

Name

GUARDIANNAME

Code

GUARDIANNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna GUARDIANRELATIONSHIPCODE tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANRELATIONSHIPCODE tabeli SLR_SICKLEAVE

Name

GUARDIANRELATIONSHIPCODE

Code

GUARDIANRELATIONSHIPCODE

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna GUARDIANRELATIONSHIPID tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANRELATIONSHIPID tabeli SLR_SICKLEAVE

Name

GUARDIANRELATIONSHIPID

Code

GUARDIANRELATIONSHIPID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna GUARDIANRELATIONSHIPNAME tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANRELATIONSHIPNAME tabeli SLR_SICKLEAVE

Name

GUARDIANRELATIONSHIPNAME

Code

GUARDIANRELATIONSHIPNAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna GUARDIANSURNAME tabeli SLR_SICKLEAVE

Definicja kolumny GUARDIANSURNAME tabeli SLR_SICKLEAVE

Name

GUARDIANSURNAME

Code

GUARDIANSURNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna HOSPISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny HOSPISPRINTED tabeli SLR_SICKLEAVE

Name

HOSPISPRINTED

Code

HOSPISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna HOSPMEDICALHISTORYNUMBER tabeli SLR_SICKLEAVE

Definicja kolumny HOSPMEDICALHISTORYNUMBER tabeli SLR_SICKLEAVE

Name

HOSPMEDICALHISTORYNUMBER

Code

HOSPMEDICALHISTORYNUMBER

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna HOSPSTARTDT tabeli SLR_SICKLEAVE

Definicja kolumny HOSPSTARTDT tabeli SLR_SICKLEAVE

Name

HOSPSTARTDT

Code

HOSPSTARTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna HOSPSTOPDT tabeli SLR_SICKLEAVE

Definicja kolumny HOSPSTOPDT tabeli SLR_SICKLEAVE

Name

HOSPSTOPDT

Code

HOSPSTOPDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna HPDADDRESS tabeli SLR_SICKLEAVE

Definicja kolumny HPDADDRESS tabeli SLR_SICKLEAVE

Name

HPDADDRESS

Code

HPDADDRESS

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna HPDBINNUMBER tabeli SLR_SICKLEAVE

Definicja kolumny HPDBINNUMBER tabeli SLR_SICKLEAVE

Name

HPDBINNUMBER

Code

HPDBINNUMBER

Data Type

VARCHAR2(14)

Mandatory

Yes

Comment

 


Kolumna HPDISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny HPDISPRINTED tabeli SLR_SICKLEAVE

Name

HPDISPRINTED

Code

HPDISPRINTED

Data Type

NUMBER(1,0)

Mandatory

Yes

Comment

 


Kolumna HPDNAME tabeli SLR_SICKLEAVE

Definicja kolumny HPDNAME tabeli SLR_SICKLEAVE

Name

HPDNAME

Code

HPDNAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna MAINSLRID tabeli SLR_SICKLEAVE

Definicja kolumny MAINSLRID tabeli SLR_SICKLEAVE

Name

MAINSLRID

Code

MAINSLRID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna MAINSLRNUMBER tabeli SLR_SICKLEAVE

Definicja kolumny MAINSLRNUMBER tabeli SLR_SICKLEAVE

Name

MAINSLRNUMBER

Code

MAINSLRNUMBER

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli SLR_SICKLEAVE

Definicja kolumny LASTMODIFIEDDT tabeli SLR_SICKLEAVE

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

TIMESTAMP

Mandatory

Yes

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli SLR_SICKLEAVE

Definicja kolumny LASTMODIFIEDPERSON tabeli SLR_SICKLEAVE

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Kolumna MSEDISABILITYGROUP tabeli SLR_SICKLEAVE

Definicja kolumny MSEDISABILITYGROUP tabeli SLR_SICKLEAVE

Name

MSEDISABILITYGROUP

Code

MSEDISABILITYGROUP

Data Type

NUMBER(10,0)

Mandatory

No

Comment

 


Kolumna MSEDISABILITYGROUPISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny MSEDISABILITYGROUPISPRINTED tabeli SLR_SICKLEAVE

Name

MSEDISABILITYGROUPISPRINTED

Code

MSEDISABILITYGROUPISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna MSEDOCUMENTDT tabeli SLR_SICKLEAVE

Definicja kolumny MSEDOCUMENTDT tabeli SLR_SICKLEAVE

Name

MSEDOCUMENTDT

Code

MSEDOCUMENTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna MSEDOCUMENTDTISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny MSEDOCUMENTDTISPRINTED tabeli SLR_SICKLEAVE

Name

MSEDOCUMENTDTISPRINTED

Code

MSEDOCUMENTDTISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna MSEEXAMDT tabeli SLR_SICKLEAVE

Definicja kolumny MSEEXAMDT tabeli SLR_SICKLEAVE

Name

MSEEXAMDT

Code

MSEEXAMDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna MSEEXAMDTISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny MSEEXAMDTISPRINTED tabeli SLR_SICKLEAVE

Name

MSEEXAMDTISPRINTED

Code

MSEEXAMDTISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna MSEREFERRALDT tabeli SLR_SICKLEAVE

Definicja kolumny MSEREFERRALDT tabeli SLR_SICKLEAVE

Name

MSEREFERRALDT

Code

MSEREFERRALDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna MSEREFERRALDTISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny MSEREFERRALDTISPRINTED tabeli SLR_SICKLEAVE

Name

MSEREFERRALDTISPRINTED

Code

MSEREFERRALDTISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna NEXTCONTINUATIONDOCUMENTID tabeli SLR_SICKLEAVE

Definicja kolumny NEXTCONTINUATIONDOCUMENTID tabeli SLR_SICKLEAVE

Name

NEXTCONTINUATIONDOCUMENTID

Code

NEXTCONTINUATIONDOCUMENTID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna NEXTCONTDOCNUMBER tabeli SLR_SICKLEAVE

Definicja kolumny NEXTCONTDOCNUMBER tabeli SLR_SICKLEAVE

Name

NEXTCONTDOCNUMBER

Code

NEXTCONTDOCNUMBER

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna NEXTCONTDOCNUMBERWASPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny NEXTCONTDOCNUMBERWASPRINTED tabeli SLR_SICKLEAVE

Name

NEXTCONTDOCNUMBERWASPRINTED

Code

NEXTCONTDOCNUMBERWASPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna NEXTLINKEDCONTDOCWASPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny NEXTLINKEDCONTDOCWASPRINTED tabeli SLR_SICKLEAVE

Name

NEXTLINKEDCONTDOCWASPRINTED

Code

NEXTLINKEDCONTDOCWASPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna OTHERHPD tabeli SLR_SICKLEAVE

Definicja kolumny OTHERHPD tabeli SLR_SICKLEAVE

Name

OTHERHPD

Code

OTHERHPD

Data Type

NUMBER(1,0)

Mandatory

Yes

Comment

 


Kolumna PATIENTBIRTHDT tabeli SLR_SICKLEAVE

Definicja kolumny PATIENTBIRTHDT tabeli SLR_SICKLEAVE

Name

PATIENTBIRTHDT

Code

PATIENTBIRTHDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PATIENTFATHERHOOD tabeli SLR_SICKLEAVE

Definicja kolumny PATIENTFATHERHOOD tabeli SLR_SICKLEAVE

Name

PATIENTFATHERHOOD

Code

PATIENTFATHERHOOD

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna PATIENTID tabeli SLR_SICKLEAVE

Definicja kolumny PATIENTID tabeli SLR_SICKLEAVE

Name

PATIENTID

Code

PATIENTID

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Kolumna PATIENTNAME tabeli SLR_SICKLEAVE

Definicja kolumny PATIENTNAME tabeli SLR_SICKLEAVE

Name

PATIENTNAME

Code

PATIENTNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna PATIENTSEX tabeli SLR_SICKLEAVE

Definicja kolumny PATIENTSEX tabeli SLR_SICKLEAVE

Name

PATIENTSEX

Code

PATIENTSEX

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna PATIENTSURNAME tabeli SLR_SICKLEAVE

Definicja kolumny PATIENTSURNAME tabeli SLR_SICKLEAVE

Name

PATIENTSURNAME

Code

PATIENTSURNAME

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna PERSONALDATAISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny PERSONALDATAISPRINTED tabeli SLR_SICKLEAVE

Name

PERSONALDATAISPRINTED

Code

PERSONALDATAISPRINTED

Data Type

NUMBER(1,0)

Mandatory

Yes

Comment

 


Kolumna PREVCONTINUATIONDOCUMENTID tabeli SLR_SICKLEAVE

Definicja kolumny PREVCONTINUATIONDOCUMENTID tabeli SLR_SICKLEAVE

Name

PREVCONTINUATIONDOCUMENTID

Code

PREVCONTINUATIONDOCUMENTID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna PREVCONDOCUMENTNUMBER tabeli SLR_SICKLEAVE

Definicja kolumny PREVCONDOCUMENTNUMBER tabeli SLR_SICKLEAVE

Name

PREVCONDOCUMENTNUMBER

Code

PREVCONDOCUMENTNUMBER

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna PREVCONTDOCNUMBERWASPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny PREVCONTDOCNUMBERWASPRINTED tabeli SLR_SICKLEAVE

Name

PREVCONTDOCNUMBERWASPRINTED

Code

PREVCONTDOCNUMBERWASPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna PREVLINKEDCONTDOCWASPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny PREVLINKEDCONTDOCWASPRINTED tabeli SLR_SICKLEAVE

Name

PREVLINKEDCONTDOCWASPRINTED

Code

PREVLINKEDCONTDOCWASPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna REASONCODE tabeli SLR_SICKLEAVE

Definicja kolumny REASONCODE tabeli SLR_SICKLEAVE

Name

REASONCODE

Code

REASONCODE

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Kolumna REASONID tabeli SLR_SICKLEAVE

Definicja kolumny REASONID tabeli SLR_SICKLEAVE

Name

REASONID

Code

REASONID

Data Type

VARCHAR2(12)

Mandatory

Yes

Comment

 


Kolumna REASONISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny REASONISPRINTED tabeli SLR_SICKLEAVE

Name

REASONISPRINTED

Code

REASONISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna REFINSTITUTIONNUMBER tabeli SLR_SICKLEAVE

Definicja kolumny REFINSTITUTIONNUMBER tabeli SLR_SICKLEAVE

Name

REFINSTITUTIONNUMBER

Code

REFINSTITUTIONNUMBER

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna REFNUMBER tabeli SLR_SICKLEAVE

Definicja kolumny REFNUMBER tabeli SLR_SICKLEAVE

Name

REFNUMBER

Code

REFNUMBER

Data Type

VARCHAR2(7)

Mandatory

No

Comment

 


Kolumna SICKLEAVENUMBER tabeli SLR_SICKLEAVE

Definicja kolumny SICKLEAVENUMBER tabeli SLR_SICKLEAVE

Name

SICKLEAVENUMBER

Code

SICKLEAVENUMBER

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna SICKLEAVENUMBERISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny SICKLEAVENUMBERISPRINTED tabeli SLR_SICKLEAVE

Name

SICKLEAVENUMBERISPRINTED

Code

SICKLEAVENUMBERISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna STATUS tabeli SLR_SICKLEAVE

Definicja kolumny STATUS tabeli SLR_SICKLEAVE

Name

STATUS

Code

STATUS

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna TOTSLDAYSFROMPREVLINKEDCONTID tabeli SLR_SICKLEAVE

Definicja kolumny TOTSLDAYSFROMPREVLINKEDCONTID tabeli SLR_SICKLEAVE

Name

TOTSLDAYSFROMPREVLINKEDCONTID

Code

TOTSLDAYSFROMPREVLINKEDCONTID

Data Type

NUMBER(10,0)

Mandatory

Yes

Comment

 


Kolumna TYPE tabeli SLR_SICKLEAVE

Definicja kolumny TYPE tabeli SLR_SICKLEAVE

Name

TYPE

Code

TYPE

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

 


Kolumna TYPEISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny TYPEISPRINTED tabeli SLR_SICKLEAVE

Name

TYPEISPRINTED

Code

TYPEISPRINTED

Data Type

NUMBER(1,0)

Mandatory

Yes

Comment

 


Kolumna VIOLATIONCAUSECODE tabeli SLR_SICKLEAVE

Definicja kolumny VIOLATIONCAUSECODE tabeli SLR_SICKLEAVE

Name

VIOLATIONCAUSECODE

Code

VIOLATIONCAUSECODE

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna VIOLATIONCAUSEID tabeli SLR_SICKLEAVE

Definicja kolumny VIOLATIONCAUSEID tabeli SLR_SICKLEAVE

Name

VIOLATIONCAUSEID

Code

VIOLATIONCAUSEID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna VIOLATIONCAUSEISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny VIOLATIONCAUSEISPRINTED tabeli SLR_SICKLEAVE

Name

VIOLATIONCAUSEISPRINTED

Code

VIOLATIONCAUSEISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna VIOLATIONDT tabeli SLR_SICKLEAVE

Definicja kolumny VIOLATIONDT tabeli SLR_SICKLEAVE

Name

VIOLATIONDT

Code

VIOLATIONDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna VIOLATIONDTISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny VIOLATIONDTISPRINTED tabeli SLR_SICKLEAVE

Name

VIOLATIONDTISPRINTED

Code

VIOLATIONDTISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna WORKPLACE tabeli SLR_SICKLEAVE

Definicja kolumny WORKPLACE tabeli SLR_SICKLEAVE

Name

WORKPLACE

Code

WORKPLACE

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna WORKPLACEISPRINTED tabeli SLR_SICKLEAVE

Definicja kolumny WORKPLACEISPRINTED tabeli SLR_SICKLEAVE

Name

WORKPLACEISPRINTED

Code

WORKPLACEISPRINTED

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Lista kluczy tabeli SLR_SICKLEAVE

Name

Code

Primary

PK_SLR_SICKLEAVE

PK_SLR_SICKLEAVE

X


Klucz PK_SLR_SICKLEAVE tabeli SLR_SICKLEAVE

Definicja klucza PK_SLR_SICKLEAVE tabeli SLR_SICKLEAVE

Name

PK_SLR_SICKLEAVE

Code

PK_SLR_SICKLEAVE

Primary

Yes

Comment